Symbols | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z

# Index: D

$data_source argument: 4.3. Data Source Names
  4.4.1. Connection
  A.3.1. DBI Class Methods
$dbh database handle: 4.2.2. Database Handles
$dbh variable: A.3.1. DBI Class Methods
$DBI::err variable: 4.5.2. Error Diagnostics
  A.3.3. DBI Dynamic Attributes
$DBI::errstr variable: 4.5.2. Error Diagnostics
  A.3.3. DBI Dynamic Attributes
$DBI::rows variable ) (see rows()
$DBI::state variable: 4.5.2. Error Diagnostics
  7.3.2. Standard Error Codes
  A.3.3. DBI Dynamic Attributes
$drh driver handle: 4.2.1. Driver Handles
data
  compression: 8.2.2.2. Compression
  deleting: 2.2. Query Languages and Data Functions
    3.4.2. Deleting Data
    5.2. Executing Non-SELECT Statements
    delimited-field files: 2.4.4. Deleting Data
    fixed-length record files: 2.4.4. Deleting Data
  encryption: 8.2.2.3. Ciphers
  fetching: 2.2. Query Languages and Data Functions
    using DBI: 5.1.3. Fetching Data
    fetchrow_array(): 5.1.3. Fetching Data
    fetchrow_arrayref(): 5.1.3. Fetching Data
    fetchrow_hashref(): 5.1.3. Fetching Data
    finishing early: 5.1.4. Finishing a Data Fetch Early
    piece-by-piece: 6.2. Handling LONG/LOB Data
    printing and: 5.1.3.1. A quick way to fetch and print
    selectall_arrayref(): 5.6.2. Batch Fetching
      A.6.1. Database Handle Methods
    selectcol_arrayref(): A.6.1. Database Handle Methods
    selectrow_array(): 5.6.1. Atomic Fetching
      A.6.1. Database Handle Methods
    selectrow_arrayref(): 5.6.1. Atomic Fetching
  inserting: 2.2. Query Languages and Data Functions
    3.4.1. Inserting Data
    5.2. Executing Non-SELECT Statements
    delimited-field files: 2.4.2. Inserting Data
    fixed-length record files: 2.4.2. Inserting Data
    using quote(): 4.6.1. Database-Specific Quote Handling
  long values, truncating: 6.1.4. Common Attributes
  marshalling modules
    Data::Dumper: 2. Basic Non-DBI Databases
      2.5.1. The Perl Data::Dumper Module
    Storable: 2. Basic Non-DBI Databases
      2.5.2. The Storable Module
  modifying within tables: 3.4. Modifying Data Within Tables
    committing changes: 3.4.4. Committing and Rolling Back Modifications
      6.3.1. Automatic Transaction Handling
    deleting data: 3.4.2. Deleting Data
    inserting data: 3.4.1. Inserting Data
    undoing changes: 3.4.4. Committing and Rolling Back Modifications
      6.3.3. Rolling Back Changes
    updating data: 3.4.3. Updating Data
  querying: 2.4.1. Querying Data
    delimited-field files: 2.4.1. Querying Data
    fixed-length record files: 2.4.1. Querying Data
    from multiple tables: 3.3.3. Queries over Multiple Tables
    from single tables: 3.3.2. Queries and Condition Clauses
    using SQL: 3.3. Querying Data
  rolling back: 6.3. Transactions, Locking, and Isolation
  selecting: 2.2. Query Languages and Data Functions
    2.4.1. Querying Data
  serializing: 2.5. Putting Complex Data into Flat Files
    2.8. The MLDBM Module
  storing (see data, inserting)
  trailing blanks, removing: 6.1.4. Common Attributes
  truncating long values: 6.1.4. Common Attributes
    6.2. Handling LONG/LOB Data
  updating: 2.2. Query Languages and Data Functions
    3.4.3. Updating Data
    5.2. Executing Non-SELECT Statements
    delimited-field files: 2.4.3. Updating Data
    fixed-length record files: 2.4.3. Updating Data
data source names: 4.3. Data Source Names
  available_drivers(): 4.3. Data Source Names
  connect() and: 4.3. Data Source Names
    6.1.2. Connecting with Attributes
  data_sources(): 4.3. Data Source Names
  name=value pairs: 4.3. Data Source Names
data structures, storing complex: 2.8. The MLDBM Module
data warehousing: 1.1. From Mainframes to Workstations
  3.1. The Relational Database Methodology
  3.4. Modifying Data Within Tables
database drivers
  connection syntax examples
    CSV: 4.3. Data Source Names
    mSQL: 4.3. Data Source Names
    Oracle: 4.3. Data Source Names
  DBI: 4.1. DBI Architecture
    B.1. Acquiring the DBI and Drivers
  prefixes: 4.3. Data Source Names
    6.1.3. The Significance of Case
    A.2.5. Naming Conventions and Name Space
  standard: 4.3. Data Source Names
database handles: 4.2.2. Database Handles
  atomic fetching and: 5.6.1. Atomic Fetching
  attributes: 6.1.5. Database Handle Attributes
    connecting with: 6.1.2. Connecting with Attributes
    driver-specific: 6.1. Handle Attributes and Metadata
      6.1.3. The Significance of Case
    error checking: 6.1.4. Common Attributes
    getting or setting values: 6.1. Handle Attributes and Metadata
    passing to DBI methods: 6.1.1. Passing Attributes to DBI Methods
  $dbh: 4.2.2. Database Handles
  retrieving entity metadata: 6.1.6. Database Metadata
database-independent programming interfaces: 1.1. From Mainframes to Workstations
  7. ODBC and the DBI
database metadata: 6.1.6. Database Metadata
databases
  accessing using proxying: 8.2. Database Proxying
  basic attributes: 2. Basic Non-DBI Databases
  Berkeley (see Berkeley databases)
  committing changes: 6.3. Transactions, Locking, and Isolation
  concurrent access to: 2.6. Concurrent Database Access and Locking
  connecting to: 4.4.1. Connection
    requirements: 4.4.1. Connection
    with dbish: 8.1.1. Starting Up dbish
  creating new tables: 3.5. Creating and Destroying Tables
  cursors: 5.1.3. Fetching Data
  deleting tables: 3.5. Creating and Destroying Tables
    3.5. Creating and Destroying Tables
  disconnecting from: 4.4.2. Disconnection
    6.3.4. Disconnecting, One Way or Another
  evolution from mainframes to workstations: 1.1. From Mainframes to Workstations
  executing SQL statements: 5.1.2. Executing Select Statements
  extracting table information, example: 6.1.7. Statement Handle Attributes or Statement Metadata
  fetching data: 5.1. Issuing Simple Queries
    using DBI: 5.1.3. Fetching Data
  file locking: 2.6. Concurrent Database Access and Locking
  flat-file (see flat-file databases)
  generating dynamic views: 6.1.6. Database Metadata
  locking
    Berkeley databases: 2.7.2. Locking Strategies
    flat-file databases: 2.6. Concurrent Database Access and Locking
  preparing SQL statements: 5.1.1. Preparing SQL Statements
  proxying: 8.2. Database Proxying
  queries, issuing simple: 5.1. Issuing Simple Queries
  query languages (see query languages)
  quoting and escaping SQL statements: 4.6.1. Database-Specific Quote Handling
  relational: 3.1. The Relational Database Methodology
  result sets: 5.1.3. Fetching Data
  retrieving entity metadata: 6.1.6. Database Metadata
  rolling back changes: 6.3. Transactions, Locking, and Isolation
  schemas: 3.1. The Relational Database Methodology
    6.1.6. Database Metadata
  storage managers and layers: 2.1. Storage Managers and Layers
  system catalogs: 6.1.6. Database Metadata
Data::Dumper module: 2. Basic Non-DBI Databases
  2.5.1. The Perl Data::Dumper Module
  displaying restored data: 2.8. The MLDBM Module
DataHash(): 7.4.2. Win32::ODBC
data_sources(): A.3.1. DBI Class Methods
  available_drivers() and: 4.3. Data Source Names
  driver handles and: 4.2.1. Driver Handles
datatypes: 3.2. Datatypes and NULL Values
  binary large object: 3.2. Datatypes and NULL Values
    6.1.4. Common Attributes
  bind values and: 5.3.2. Bind Values and Data Typing
  character: 3.2. Datatypes and NULL Values
  date: 3.2. Datatypes and NULL Values
  LOB (large object): 6.2. Handling LONG/LOB Data
  LONG: 6.1.4. Common Attributes
    6.2. Handling LONG/LOB Data
  numeric: 3.2. Datatypes and NULL Values
date datatype: 3.2. Datatypes and NULL Values
DB2 (see DBD\\DB2 driver)
db database manager: 2.7. DBM Files and the BerkeleyDatabase Manager
DB_BTREE storage format: 2.7.1. Creating a New Database
  2.7.3.5. Chaining multiple values into a hash
DBD::ADO driver: B. Driver and Database Characteristics
  connect syntax: B. Driver and Database Characteristics
  datatypes: B. Driver and Database Characteristics
  SQL dialect: B. Driver and Database Characteristics
DBD::CSV driver: B. Driver and Database Characteristics
  connect syntax: B. Driver and Database Characteristics
  datatypes: B. Driver and Database Characteristics
  driver-specific attributes: B. Driver and Database Characteristics
  SQL dialect: B. Driver and Database Characteristics
  table metadata: B. Driver and Database Characteristics
DBD::DB2 driver: B. Driver and Database Characteristics
  connect syntax: B. Driver and Database Characteristics
  datatypes: B. Driver and Database Characteristics
  parameter binding: B. Driver and Database Characteristics
  SQL dialect: B. Driver and Database Characteristics
  transactions: B. Driver and Database Characteristics
DBD::Empress driver: B. Driver and Database Characteristics
  connect syntax: B. Driver and Database Characteristics
  datatypes: B. Driver and Database Characteristics
  parameter binding: B. Driver and Database Characteristics
  SQL dialect: B. Driver and Database Characteristics
  transactions: B. Driver and Database Characteristics
DBD::EmpressNet driver (see DBD\\Empress driver)
DBD::Informix driver: B. Driver and Database Characteristics
  connect syntax: B. Driver and Database Characteristics
  datatypes: B. Driver and Database Characteristics
  SQL dialect: B. Driver and Database Characteristics
  stored procedures: B. Driver and Database Characteristics
  table metadata: B. Driver and Database Characteristics
  transactions: B. Driver and Database Characteristics
DBD::Ingres driver: B. Driver and Database Characteristics
  connect syntax: B. Driver and Database Characteristics
  datatypes: B. Driver and Database Characteristics
  driver-specific attributes: B. Driver and Database Characteristics
  parameter binding: B. Driver and Database Characteristics
  SQL dialect: B. Driver and Database Characteristics
  table metadata: B. Driver and Database Characteristics
  transactions: B. Driver and Database Characteristics
DBD::InterBase driver: B. Driver and Database Characteristics
  connect syntax: B. Driver and Database Characteristics
  datatypes: B. Driver and Database Characteristics
  parameter binding: B. Driver and Database Characteristics
  SQL dialect: B. Driver and Database Characteristics
  transactions: B. Driver and Database Characteristics
DBD::mSQL driver (see DBD\\mysql driver)
DBD::mysql driver: B. Driver and Database Characteristics
  connect syntax: B. Driver and Database Characteristics
  datatypes: B. Driver and Database Characteristics
  driver-specific attributes and methods: B. Driver and Database Characteristics
  locking: B. Driver and Database Characteristics
  parameter binding: B. Driver and Database Characteristics
  SQL dialect: B. Driver and Database Characteristics
  table metadata: B. Driver and Database Characteristics
DBD::ODBC driver: B. Driver and Database Characteristics
  connect syntax: B. Driver and Database Characteristics
  datatypes: B. Driver and Database Characteristics
  SQL dialect: B. Driver and Database Characteristics
  table metadata: B. Driver and Database Characteristics
DBD::ODBC module
  vs. Win32::ODBC: 7.4.1. DBD::ODBC
DBD::Oracle driver: B. Driver and Database Characteristics
  connect syntax: B. Driver and Database Characteristics
  datatypes: B. Driver and Database Characteristics
  driver-specific methods: B. Driver and Database Characteristics
  parameter binding: B. Driver and Database Characteristics
  SQL dialect: B. Driver and Database Characteristics
  stored procedures: B. Driver and Database Characteristics
  table metadata: B. Driver and Database Characteristics
  transactions: B. Driver and Database Characteristics
DBD::Pg driver: B. Driver and Database Characteristics
  connect syntax: B. Driver and Database Characteristics
  datatypes: B. Driver and Database Characteristics
  driver-specific attributes: B. Driver and Database Characteristics
  parameter binding: B. Driver and Database Characteristics
  SQL dialect: B. Driver and Database Characteristics
  transactions: B. Driver and Database Characteristics
DBD::Proxy module: 8.2.1. The Database Proxy Architecture
  8.2.1.2. Connecting to the proxy server
  A.3.1. DBI Class Methods
DBDs (see database drivers)
DBD::SearchServer driver: B. Driver and Database Characteristics
  connect syntax: B. Driver and Database Characteristics
  datatypes: B. Driver and Database Characteristics
  locking: B. Driver and Database Characteristics
  parameter binding: B. Driver and Database Characteristics
  SQL dialect: B. Driver and Database Characteristics
DBD::Sybase driver: B. Driver and Database Characteristics
  connect syntax: B. Driver and Database Characteristics
  datatypes: B. Driver and Database Characteristics
  driver-specific attributes and methods: B. Driver and Database Characteristics
  parameter binding: B. Driver and Database Characteristics
  SQL dialect: B. Driver and Database Characteristics
  stored procedures: B. Driver and Database Characteristics
  transactions: B. Driver and Database Characteristics
DBD::XBase driver: B. Driver and Database Characteristics
  connect syntax: B. Driver and Database Characteristics
  datatypes: B. Driver and Database Characteristics
  parameter binding: B. Driver and Database Characteristics
  SQL dialect: B. Driver and Database Characteristics
  table metadata: B. Driver and Database Characteristics
DB_File module: 2.7. DBM Files and the BerkeleyDatabase Manager
  2.8. The MLDBM Module
  default values: 2.7.1. Creating a New Database
  using for storage: 2.8. The MLDBM Module
  using seq(): 2.7.3.5. Chaining multiple values into a hash
DB_HASH storage format: 2.7.1. Creating a New Database
  2.7.3.5. Chaining multiple values into a hash
DBI: 1. Introduction
  application architecture: A.2.1. Architecture of a DBI Application
  architecture: 4.1. DBI Architecture
  combining with ODBC: 7.5. The Marriage of DBI and ODBC
  connecting to databases: 4.3. Data Source Names
  conventions: A.2.2. Notation and Conventions
  data flow through: 4.1. DBI Architecture
  data source names (see data source names)
  database drivers: 4.1. DBI Architecture
  database proxying: 8.2. Database Proxying
  downloading source code: B.1. Acquiring the DBI and Drivers
  error codes: 7.3.2. Standard Error Codes
  error handling (see error handling)
  execution tracing: 4.6.2. Tracing DBI Execution
  formatting output generated by tracing: 4.6.3. Neat and Tidy Formatting
  handles (see handles)
  home page: A.1.1. Getting Help
  implementing drivers: 4.1. DBI Architecture
  implementing SQL: 7.3.1. A Standard SQL Syntax
  installing: B.1. Acquiring the DBI and Drivers
  integrating databases and web sites: 5.1.1.1. Constructing "on-the-fly" statements
  interface rules: A.2.4. General Interface Rules and Caveats
  metadata functions: 7.3.3. Rich Metadata
  module: 4.1. DBI Architecture
  naming conventions: A.2.5. Naming Conventions and Name Space
  proxy architecture: 8.2.1. The Database Proxy Architecture
  proxy servers (see proxy servers)
  real-world uses: 1.3. DBI in the Real World
  shell program (dbish): 8.1. dbish--The DBI Shell
  specification: A. DBI Specification
  statement preparation data flow: 5.1.1. Preparing SQL Statements
  supporting databases: 4.1. DBI Architecture
  synopsis: A.1. Synopsis
  transaction handling (see transaction handling)
  usage summary: A.2.3. Outline Usage
  utility functions (see utility functions)
  utility methods (see utility methods)
  using Win32::DBIODBC module: 7.7. Moving Between Win32::ODBC and the DBI
DBI->available_drivers() ) (see available_drivers()
DBI->connect() ) (see connect())
DBI->data_sources() ) (see data_sources()
DBI->trace() ) (see trace()
DBI->trace_msg() ) (see trace_msg()
DBI methods, passing attributes to: 6.1.1. Passing Attributes to DBI Methods
dbi-users mailing list: A.9.4. Mailing List
DBI_AUTOPROXY environment variable: 8.2.1.2. Connecting to the proxy server
  A.3.1. DBI Class Methods
DBI_DSN environment variable: 4.3. Data Source Names
  6.1.2. Connecting with Attributes
  A.3.1. DBI Class Methods
DBI::neat_list(): 8.1.2. Handling Statements
DBI_PASS environment variable: A.3.1. DBI Class Methods
dbiproxy script: 8.2.1.1. Setting up a proxy server
  8.2.2.1. Access configuration
DBI::ProxyServer module: 8.2.1. The Database Proxy Architecture
  8.2.2. Advanced Topics
dbish (DBI shell): 8.1. dbish--The DBI Shell
  command syntax: 8.1.2. Handling Statements
  issuing ad-hoc SQL statements: 8.1.2. Handling Statements
  miscellaneous commands: 8.1.3. Some Miscellaneous dbish Commands
DBI_TRACE environment variable: 4.6.2. Tracing DBI Execution
DBI_USER environment variable: A.3.1. DBI Class Methods
DBM file libraries: 2.1. Storage Managers and Layers
DBM files: 2.7. DBM Files and the BerkeleyDatabase Manager
  accessor methods: 2.7.3.3. Object accessor methods
  Berkeley databases and: 2.7. DBM Files and the BerkeleyDatabase Manager
  chaining multiple values into a hash: 2.7.3.5. Chaining multiple values into a hash
  creating new databases: 2.7.1. Creating a New Database
  deleting values: 2.7.4. Deleting Values
  file descriptors: 2.7.2. Locking Strategies
  hashtables, querying limitations: 2.7.3.4. Querying limitations of DBM files and hashtables
  key/value pairs: 2.7. DBM Files and the BerkeleyDatabase Manager
    2.7.3. Inserting and Retrieving Values
  localized storage and retrieval: 2.7.3.1. Localized storage and retrieval
  packing in Perl objects: 2.7.3.2. Packing in Perl objects
  storing data using join() or pack(): 2.7.3.1. Localized storage and retrieval
DBperl: 7.2. DBI--Thrashed and Mutated
DB_RECNO storage format: 2.7.1. Creating a New Database
DDL (Data Definition Language) commands: 3.5. Creating and Destroying Tables
debugging ) (see trace()
delete operator, Perl: 2.7.4. Deleting Values
DELETE SQL statement: 3.4.2. Deleting Data
delimited-field files
  deleting data: 2.4.4. Deleting Data
  inserting data: 2.4.2. Inserting Data
  querying data: 2.4.1. Querying Data
  updating data: 2.4.3. Updating Data
delimited fields, choosing vs. fixed-length records: 2.4.1. Querying Data
delimiting characters: 2.4. Flat-File Databases
DESC SQL statement: 3.3.4.1. Ordering data
DESTROY method: 4.4.2. Disconnection
  6.3.4. Disconnecting, One Way or Another
  A.6.1. Database Handle Methods
diagnostics, error (see error diagnostics)
die(): 4.5.1. Automatic Versus Manual Error Checking
  5.1.2. Executing Select Statements
  5.1.4. Finishing a Data Fetch Early
  automatic error checking: 4.5.1.2. Automatic error checking
  used with RaiseError: 6.1.4. Common Attributes
disconnect(): 4.4.2. Disconnection
  5.1.4. Finishing a Data Fetch Early
  A.6.1. Database Handle Methods
  transaction handling: 6.3.4. Disconnecting, One Way or Another
distributed environments: 1.1. From Mainframes to Workstations
DML (Data Manipulation Language) commands: 3.3. Querying Data
  3.4. Modifying Data Within Tables
do(): 5.2. Executing Non-SELECT Statements
  A.6.1. Database Handle Methods
  vs. prepare(): 5.5. do( ) Versus prepare( )
Driver database handle attribute: A.6.2.3. Databases in which a transaction must be explicitly started
driver handles: 4.2.1. Driver Handles
driver-specific attributes: 6.1. Handle Attributes and Metadata
dump_results(): 5.1.3.1. A quick way to fetch and print
  A.7.1.1. Datatypes for placeholders

Symbols | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z

Copyright © 2001 O'Reilly & Associates, Inc. All Rights Reserved.